﻿CREATE TABLE [dbo].[ClinRecipeDetail]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [ClinRecipeId] INT NULL, 
    [RecipeId] NVARCHAR(50) NULL, 
    [FeeName] NVARCHAR(50) NULL, 
    [FeeCode] NVARCHAR(50) NULL, 
    [Spec] NVARCHAR(50) NULL, 
    [Price] NVARCHAR(50) NULL, 
    [Qty] NVARCHAR(50) NULL, 
    [Unit] NVARCHAR(50) NULL, 
    [Amt] NVARCHAR(50) NULL, 
    [Sort] NVARCHAR(50) NULL 
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'ClinRecipe.Id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'ClinRecipeId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'主键，自增长',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'Id'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'处方Id',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'RecipeId'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'收费项目名称',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'FeeName'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'收费项目编号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'FeeCode'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'规格',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'Spec'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'单价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'Price'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'数量',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'Qty'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'单位',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'Unit'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'总价',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'Amt'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'排序号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'ClinRecipeDetail',
    @level2type = N'COLUMN',
    @level2name = N'Sort'